Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RENAME

The RENAME command changes the name of an analytic workspace or an object in an analytical workspace.

Syntax

RENAME oldname newname [AW workspace]

Arguments

oldname

  The name of an existing analytic workspace or an existing object in an analytic workspace. You can specify a qualified object name to indicate the attached workspace in which the object resides. As an alternative, you can use the AW keyword to specify the workspace. Do not use both.

  When you do not use a qualified object name or the AW keyword to specify a workspace, the object is renamed in the current workspace.

  For an unnamed composite, use the same syntax that was used to create it. See "Naming an Unnamed Composite".

newname

  The new name.

  - The new name of an analytic workspace cannot duplicate any other name of a workspace in the schema in which the workspace is defined. Choose a name according to the rules for naming analytic workspaces (see the AW command).

  - The new name of an analytic workspace object cannot duplicate any other name in the workspace in which the object exists. Choose a name according to the rules for naming analytic workspace objects (see DEFINE. To change a named composite to an unnamed composite, use the SPARSE keyword as the newname argument. See "Unnaming a Named Composite".

AW workspace

  The name of an attached workspace in which you wish to rename the object. When you do not use a qualified object name or the AW keyword to specify a workspace, the object is renamed in the current workspace.

Notes

Updating Associated Objects

When you change the name of a variable, objects that use that variable, such as formulas, are not automatically updated.

When you change the name of a dimension, the definitions of any objects that are dimensioned by that dimension are automatically updated. Additionally, any valuesets for the renamed dimension are automatically updated for the new name.

RENAME and PERMIT

You may not rename an object when a PERMIT statement denies you the right to change its permission. Renaming an object does not affect permission associated with it.

Naming an Unnamed Composite

You can name an unnamed composite with a RENAME statement. The following example assigns the name `m.prod` to an unnamed composite that is dimensioned by `market` and `product`.

    RENAME SPARSE <market product> m.prod

Unnaming a Named Composite

You can change a named composite to an unnamed composite when the composite has no properties or permission restrictions and when there is at least one object dimensioned by it. In addition, there cannot be an unnamed composite with the same dimensions in the same order as the named composite, and the named composite cannot be used in the dimension list of any unnamed composite. To change a named composite to an unnamed composite, use the SPARSE keyword as the newname argument. The following example changes the named composite `m.prod` to an unnamed composite.

    RENAME m.prod SPARSE

Restrictions on Renaming Composites

You cannot rename a composite when it is a base dimension of an unnamed composite, or when one of its base dimensions is an unnamed composite.

Examples

Example 20-21 Renaming a Program

This statement changes the name of the program `testreport` to `sales.report`.

    RENAME testreport sales.report